Export text strings to an Excel spreadsheet

If an application supports multiple languages, you can export the text strings for all the application languages to a Microsoft Excel spreadsheet (*.xls). The following versions of Microsoft Excel are supported:

  • Excel 2000
  • Excel 2002
  • Excel 2003
  • Excel 2007
  • Excel 2010
  • Excel 2013

To export text strings in an application to an Excel spreadsheet

  1. In the Language Configuration dialog box, click Export.
  2. In the Export Operation window, select Export strings for all languages to an Excel spreadsheet.
  3. If you select the Optimize duplicate strings check box, the strings that appear repeatedly in the application appear only once in the spreadsheet, and need only be translated or edited once. When the file is imported, each instance of a duplicate string is replaced by the same edited or translated string.
  4. If you select the Open exported file check box, the exported file opens as soon as the export is finished.
  5. Select a destination for the exported text strings.

    Tip:

    • The default name for an exported Excel file is:

      <application name>_<export version number>.xls

      For example, Brewery_1.xls

      The first time you export strings to Excel, the export version number is 1. For each subsequent export from the same application, the number increases by 1.

    • When you export strings to an Excel spreadsheet, undefined strings are exported as "**UNDEFINED**". If this is not replaced with a text string during the translation process, an undefined string will be imported into the application.
    • For the instructions on opening a text file in Microsoft Excel, see "Set up language switching" in the FactoryTalk View Machine Edition User's Guide.

See also

Export Operation dialog box

Export text strings to a Unicode text file

Select a destination for the exported text strings

Tips for exporting text strings

Text strings that cannot be exported or imported